Dataset statistics
| Number of variables | 17 |
|---|---|
| Number of observations | 71102 |
| Missing cells | 26294 |
| Missing cells (%) | 2.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 26.6 MiB |
| Average record size in memory | 392.0 B |
Variable types
| NUM | 11 |
|---|---|
| CAT | 6 |
anio has constant value "71102" | Constant |
colonia has a high cardinality: 1340 distinct values | High cardinality |
consumo_prom_no_dom is highly correlated with consumo_prom | High correlation |
consumo_prom is highly correlated with consumo_prom_no_dom | High correlation |
gid is highly correlated with bimestre | High correlation |
bimestre is highly correlated with gid | High correlation |
alcaldia is highly correlated with nomgeo | High correlation |
nomgeo is highly correlated with alcaldia | High correlation |
consumo_total_mixto has 8327 (11.7%) missing values | Missing |
consumo_prom_dom has 4820 (6.8%) missing values | Missing |
consumo_total_dom has 4820 (6.8%) missing values | Missing |
consumo_prom_mixto has 8327 (11.7%) missing values | Missing |
consumo_total_mixto is highly skewed (γ1 = 21.76535468) | Skewed |
consumo_prom_dom is highly skewed (γ1 = 74.81862948) | Skewed |
consumo_prom_mixto is highly skewed (γ1 = 43.60044406) | Skewed |
consumo_prom is highly skewed (γ1 = 43.38268186) | Skewed |
consumo_prom_no_dom is highly skewed (γ1 = 40.71654298) | Skewed |
consumo_total_no_dom is highly skewed (γ1 = 22.5073679) | Skewed |
gid has unique values | Unique |
consumo_total_mixto has 17715 (24.9%) zeros | Zeros |
consumo_prom_dom has 9861 (13.9%) zeros | Zeros |
consumo_total_dom has 9861 (13.9%) zeros | Zeros |
consumo_prom_mixto has 17715 (24.9%) zeros | Zeros |
consumo_total has 2451 (3.4%) zeros | Zeros |
consumo_prom has 2451 (3.4%) zeros | Zeros |
consumo_prom_no_dom has 8109 (11.4%) zeros | Zeros |
consumo_total_no_dom has 8109 (11.4%) zeros | Zeros |
Reproduction
| Analysis started | 2020-10-01 20:06:14.227906 |
|---|---|
| Analysis finished | 2020-10-01 20:07:05.797070 |
| Duration | 51.57 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 24339 |
|---|---|
| Distinct (%) | 38.8% |
| Missing | 8327 |
| Missing (%) | 11.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 174.3599291 |
|---|---|
| Minimum | 0 |
| Maximum | 23404.44 |
| Zeros | 17715 |
| Zeros (%) | 24.9% |
| Memory size | 555.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 79.94 |
| Q3 | 233.32 |
| 95-th percentile | 660.779 |
| Maximum | 23404.44 |
| Range | 23404.44 |
| Interquartile range (IQR) | 233.32 |
Descriptive statistics
| Standard deviation | 312.663596 |
|---|---|
| Coefficient of variation (CV) | 1.793207864 |
| Kurtosis | 1419.360189 |
| Mean | 174.3599291 |
| Median Absolute Deviation (MAD) | 79.94 |
| Skewness | 21.76535468 |
| Sum | 10945444.55 |
| Variance | 97758.52424 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 17715 | 24.9% | |
| 36 | 74 | 0.1% | |
| 17.7 | 61 | 0.1% | |
| 36.6 | 59 | 0.1% | |
| 18.3 | 54 | 0.1% | |
| 29.28 | 52 | 0.1% | |
| 57.96 | 50 | 0.1% | |
| 23.8 | 48 | 0.1% | |
| 43.32 | 47 | 0.1% | |
| 46.98 | 46 | 0.1% | |
| 61 | 46 | 0.1% | |
| 26.84 | 45 | 0.1% | |
| 1.84 | 45 | 0.1% | |
| 11.6 | 43 | 0.1% | |
| 35.4 | 42 | 0.1% | |
| 16.48 | 41 | 0.1% | |
| 3.06 | 41 | 0.1% | |
| 28.68 | 41 | 0.1% | |
| 18.92 | 40 | 0.1% | |
| 45.76 | 40 | 0.1% | |
| 4.88 | 40 | 0.1% | |
| 27.46 | 40 | 0.1% | |
| 1.22 | 39 | 0.1% | |
| 26.24 | 39 | 0.1% | |
| 54.9 | 38 | 0.1% | |
| Other values (24314) | 43949 | 61.8% | |
| (Missing) | 8327 | 11.7% |
| Value | Count | Frequency (%) | |
| 0 | 17715 | 24.9% | |
| 0.12 | 1 | < 0.1% | |
| 0.24 | 4 | < 0.1% | |
| 0.27 | 3 | < 0.1% | |
| 0.35 | 4 | < 0.1% | |
| 0.36 | 3 | < 0.1% | |
| 0.38 | 9 | < 0.1% | |
| 0.48 | 3 | < 0.1% | |
| 0.56 | 1 | < 0.1% | |
| 0.6 | 9 | < 0.1% |
| Value | Count | Frequency (%) | |
| 23404.44 | 1 | < 0.1% | |
| 23058.9 | 1 | < 0.1% | |
| 23031.06 | 1 | < 0.1% | |
| 5979.71 | 1 | < 0.1% | |
| 5974.32 | 1 | < 0.1% | |
| 5966.71 | 1 | < 0.1% | |
| 5808 | 3 | < 0.1% | |
| 4919.04 | 1 | < 0.1% | |
| 4508.32 | 1 | < 0.1% | |
| 4331.01 | 2 | < 0.1% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 555.6 KiB |
| 2019 |
|---|
| Value | Count | Frequency (%) | |
| 2019 | 71102 | 100.0% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Most occurring characters
| Value | Count | Frequency (%) | |
| 2 | 71102 | 25.0% | |
| 0 | 71102 | 25.0% | |
| 1 | 71102 | 25.0% | |
| 9 | 71102 | 25.0% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Decimal Number | 284408 | 100.0% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 2 | 71102 | 25.0% | |
| 0 | 71102 | 25.0% | |
| 1 | 71102 | 25.0% | |
| 9 | 71102 | 25.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Common | 284408 | 100.0% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 2 | 71102 | 25.0% | |
| 0 | 71102 | 25.0% | |
| 1 | 71102 | 25.0% | |
| 9 | 71102 | 25.0% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 284408 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| 2 | 71102 | 25.0% | |
| 0 | 71102 | 25.0% | |
| 1 | 71102 | 25.0% | |
| 9 | 71102 | 25.0% |
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 555.6 KiB |
| iztapalapa | |
|---|---|
| gustavo a. madero | |
| cuauhtémoc | |
| benito juárez | |
| venustiano carranza | |
| Other values (11) |
| Value | Count | Frequency (%) | |
| iztapalapa | 10515 | 14.8% | |
| gustavo a. madero | 10058 | 14.1% | |
| cuauhtémoc | 7313 | 10.3% | |
| benito juárez | 6049 | 8.5% | |
| venustiano carranza | 5179 | 7.3% | |
| miguel hidalgo | 5110 | 7.2% | |
| coyoacán | 4947 | 7.0% | |
| azcapotzalco | 4216 | 5.9% | |
| álvaro obregón | 4140 | 5.8% | |
| iztacalco | 3469 | 4.9% | |
| tlalpan | 3204 | 4.5% | |
| xochimilco | 2450 | 3.4% | |
| tláhuac | 1955 | 2.7% | |
| la magdalena contreras | 955 | 1.3% | |
| cuajimalpa de morelos | 892 | 1.3% | |
| milpa alta | 650 | 0.9% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 22 |
|---|---|
| Median length | 12 |
| Mean length | 12.43351804 |
| Min length | 7 |
Most occurring characters
| Value | Count | Frequency (%) | |
| a | 151810 | 17.2% | |
| o | 81481 | 9.2% | |
| c | 53771 | 6.1% | |
| t | 53563 | 6.1% | |
| l | 48367 | 5.5% | |
| 44938 | 5.1% | ||
| u | 43869 | 5.0% | |
| i | 41874 | 4.7% | |
| e | 40279 | 4.6% | |
| r | 37547 | 4.2% | |
| n | 35787 | 4.0% | |
| z | 33644 | 3.8% | |
| p | 29992 | 3.4% | |
| m | 28320 | 3.2% | |
| g | 25373 | 2.9% | |
| v | 19377 | 2.2% | |
| á | 17091 | 1.9% | |
| s | 17084 | 1.9% | |
| d | 17015 | 1.9% | |
| h | 16828 | 1.9% | |
| b | 10189 | 1.2% | |
| . | 10058 | 1.1% | |
| é | 7313 | 0.8% | |
| j | 6941 | 0.8% | |
| y | 4947 | 0.6% | |
| Other values (2) | 6590 | 0.7% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Lowercase Letter | 829052 | 93.8% | |
| Space Separator | 44938 | 5.1% | |
| Other Punctuation | 10058 | 1.1% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| a | 151810 | 18.3% | |
| o | 81481 | 9.8% | |
| c | 53771 | 6.5% | |
| t | 53563 | 6.5% | |
| l | 48367 | 5.8% | |
| u | 43869 | 5.3% | |
| i | 41874 | 5.1% | |
| e | 40279 | 4.9% | |
| r | 37547 | 4.5% | |
| n | 35787 | 4.3% | |
| z | 33644 | 4.1% | |
| p | 29992 | 3.6% | |
| m | 28320 | 3.4% | |
| g | 25373 | 3.1% | |
| v | 19377 | 2.3% | |
| á | 17091 | 2.1% | |
| s | 17084 | 2.1% | |
| d | 17015 | 2.1% | |
| h | 16828 | 2.0% | |
| b | 10189 | 1.2% | |
| é | 7313 | 0.9% | |
| j | 6941 | 0.8% | |
| y | 4947 | 0.6% | |
| ó | 4140 | 0.5% | |
| x | 2450 | 0.3% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 44938 | 100.0% |
Most frequent Other Punctuation characters
| Value | Count | Frequency (%) | |
| . | 10058 | 100.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 829052 | 93.8% | |
| Common | 54996 | 6.2% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| a | 151810 | 18.3% | |
| o | 81481 | 9.8% | |
| c | 53771 | 6.5% | |
| t | 53563 | 6.5% | |
| l | 48367 | 5.8% | |
| u | 43869 | 5.3% | |
| i | 41874 | 5.1% | |
| e | 40279 | 4.9% | |
| r | 37547 | 4.5% | |
| n | 35787 | 4.3% | |
| z | 33644 | 4.1% | |
| p | 29992 | 3.6% | |
| m | 28320 | 3.4% | |
| g | 25373 | 3.1% | |
| v | 19377 | 2.3% | |
| á | 17091 | 2.1% | |
| s | 17084 | 2.1% | |
| d | 17015 | 2.1% | |
| h | 16828 | 2.0% | |
| b | 10189 | 1.2% | |
| é | 7313 | 0.9% | |
| j | 6941 | 0.8% | |
| y | 4947 | 0.6% | |
| ó | 4140 | 0.5% | |
| x | 2450 | 0.3% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 44938 | 81.7% | ||
| . | 10058 | 18.3% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 855504 | 96.8% | |
| None | 28544 | 3.2% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| a | 151810 | 17.7% | |
| o | 81481 | 9.5% | |
| c | 53771 | 6.3% | |
| t | 53563 | 6.3% | |
| l | 48367 | 5.7% | |
| 44938 | 5.3% | ||
| u | 43869 | 5.1% | |
| i | 41874 | 4.9% | |
| e | 40279 | 4.7% | |
| r | 37547 | 4.4% | |
| n | 35787 | 4.2% | |
| z | 33644 | 3.9% | |
| p | 29992 | 3.5% | |
| m | 28320 | 3.3% | |
| g | 25373 | 3.0% | |
| v | 19377 | 2.3% | |
| s | 17084 | 2.0% | |
| d | 17015 | 2.0% | |
| h | 16828 | 2.0% | |
| b | 10189 | 1.2% | |
| . | 10058 | 1.2% | |
| j | 6941 | 0.8% | |
| y | 4947 | 0.6% | |
| x | 2450 | 0.3% |
Most frequent None characters
| Value | Count | Frequency (%) | |
| á | 17091 | 59.9% | |
| é | 7313 | 25.6% | |
| ó | 4140 | 14.5% |
| Distinct | 52060 |
|---|---|
| Distinct (%) | 78.5% |
| Missing | 4820 |
| Missing (%) | 6.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.13238577 |
|---|---|
| Minimum | 0 |
| Maximum | 7796.41 |
| Zeros | 9861 |
| Zeros (%) | 13.9% |
| Memory size | 555.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 18.69054691 |
| median | 26.41424809 |
| Q3 | 36.24656251 |
| 95-th percentile | 59.39294171 |
| Maximum | 7796.41 |
| Range | 7796.41 |
| Interquartile range (IQR) | 17.5560156 |
Descriptive statistics
| Standard deviation | 64.56592495 |
|---|---|
| Coefficient of variation (CV) | 2.216293765 |
| Kurtosis | 7663.654738 |
| Mean | 29.13238577 |
| Median Absolute Deviation (MAD) | 8.738705357 |
| Skewness | 74.81862948 |
| Sum | 1930952.794 |
| Variance | 4168.758665 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 9861 | 13.9% | |
| 1.22 | 33 | < 0.1% | |
| 14.64 | 23 | < 0.1% | |
| 10.98 | 22 | < 0.1% | |
| 15.25 | 22 | < 0.1% | |
| 9.15 | 21 | < 0.1% | |
| 9.76 | 21 | < 0.1% | |
| 11.59 | 20 | < 0.1% | |
| 20.48 | 20 | < 0.1% | |
| 7.93 | 20 | < 0.1% | |
| 17.69 | 19 | < 0.1% | |
| 18.91 | 19 | < 0.1% | |
| 19.52 | 19 | < 0.1% | |
| 8.54 | 19 | < 0.1% | |
| 3.66 | 18 | < 0.1% | |
| 12.2 | 18 | < 0.1% | |
| 3.05 | 17 | < 0.1% | |
| 18.3 | 17 | < 0.1% | |
| 23.79 | 17 | < 0.1% | |
| 25.62 | 16 | < 0.1% | |
| 29.28 | 16 | < 0.1% | |
| 1.179999948 | 16 | < 0.1% | |
| 23.18 | 16 | < 0.1% | |
| 16.47 | 15 | < 0.1% | |
| 31.72 | 15 | < 0.1% | |
| Other values (52035) | 55962 | 78.7% | |
| (Missing) | 4820 | 6.8% |
| Value | Count | Frequency (%) | |
| 0 | 9861 | 13.9% | |
| 0.009999999776 | 1 | < 0.1% | |
| 0.02 | 1 | < 0.1% | |
| 0.12 | 2 | < 0.1% | |
| 0.1299999952 | 1 | < 0.1% | |
| 0.13 | 2 | < 0.1% | |
| 0.3661844864 | 1 | < 0.1% | |
| 0.3717991632 | 1 | < 0.1% | |
| 0.3747907862 | 1 | < 0.1% | |
| 0.5 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 7796.41 | 1 | < 0.1% | |
| 7581.69 | 1 | < 0.1% | |
| 6073.459961 | 1 | < 0.1% | |
| 3726.5 | 1 | < 0.1% | |
| 3622.2 | 1 | < 0.1% | |
| 3284.5 | 1 | < 0.1% | |
| 2307.77 | 1 | < 0.1% | |
| 2297.26 | 1 | < 0.1% | |
| 1971.189941 | 1 | < 0.1% | |
| 1808.04 | 1 | < 0.1% |
| Distinct | 47051 |
|---|---|
| Distinct (%) | 71.0% |
| Missing | 4820 |
| Missing (%) | 6.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1186.263611 |
|---|---|
| Minimum | 0 |
| Maximum | 95060.69 |
| Zeros | 9861 |
| Zeros (%) | 13.9% |
| Memory size | 555.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 161.635 |
| median | 604.185 |
| Q3 | 1261.445 |
| 95-th percentile | 4027.52 |
| Maximum | 95060.69 |
| Range | 95060.69 |
| Interquartile range (IQR) | 1099.81 |
Descriptive statistics
| Standard deviation | 2771.038307 |
|---|---|
| Coefficient of variation (CV) | 2.33593805 |
| Kurtosis | 248.0413047 |
| Mean | 1186.263611 |
| Median Absolute Deviation (MAD) | 517.3 |
| Skewness | 12.52320362 |
| Sum | 78627924.68 |
| Variance | 7678653.301 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 9861 | 13.9% | |
| 1.22 | 37 | 0.1% | |
| 10.98 | 21 | < 0.1% | |
| 25.62 | 20 | < 0.1% | |
| 3.66 | 20 | < 0.1% | |
| 14.64 | 20 | < 0.1% | |
| 15.25 | 19 | < 0.1% | |
| 18.3 | 19 | < 0.1% | |
| 7.93 | 19 | < 0.1% | |
| 17.69 | 18 | < 0.1% | |
| 18.91 | 18 | < 0.1% | |
| 11.59 | 17 | < 0.1% | |
| 9.76 | 16 | < 0.1% | |
| 9.15 | 16 | < 0.1% | |
| 3.05 | 16 | < 0.1% | |
| 8.54 | 16 | < 0.1% | |
| 12.2 | 15 | < 0.1% | |
| 1.18 | 15 | < 0.1% | |
| 29.28 | 15 | < 0.1% | |
| 26.23 | 14 | < 0.1% | |
| 20.13 | 14 | < 0.1% | |
| 6.1 | 14 | < 0.1% | |
| 19.52 | 14 | < 0.1% | |
| 15.86 | 14 | < 0.1% | |
| 4.27 | 14 | < 0.1% | |
| Other values (47026) | 56000 | 78.8% | |
| (Missing) | 4820 | 6.8% |
| Value | Count | Frequency (%) | |
| 0 | 9861 | 13.9% | |
| 0.12 | 1 | < 0.1% | |
| 0.24 | 1 | < 0.1% | |
| 0.5 | 2 | < 0.1% | |
| 0.6 | 1 | < 0.1% | |
| 0.61 | 4 | < 0.1% | |
| 0.62 | 1 | < 0.1% | |
| 0.72 | 3 | < 0.1% | |
| 0.73 | 1 | < 0.1% | |
| 0.85 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 95060.69 | 1 | < 0.1% | |
| 94021.7 | 1 | < 0.1% | |
| 90078.44 | 1 | < 0.1% | |
| 83309.94 | 1 | < 0.1% | |
| 82689.38 | 1 | < 0.1% | |
| 67854.6 | 2 | < 0.1% | |
| 67305.9 | 2 | < 0.1% | |
| 66914.7 | 1 | < 0.1% | |
| 66897.29 | 1 | < 0.1% | |
| 66170.67 | 3 | < 0.1% |
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 555.6 KiB |
| iztapalapa | |
|---|---|
| gustavo a. madero | |
| cuauhtemoc | |
| benito juarez | |
| venustiano carranza | |
| Other values (11) |
| Value | Count | Frequency (%) | |
| iztapalapa | 10515 | 14.8% | |
| gustavo a. madero | 10058 | 14.1% | |
| cuauhtemoc | 7313 | 10.3% | |
| benito juarez | 6049 | 8.5% | |
| venustiano carranza | 5179 | 7.3% | |
| miguel hidalgo | 5110 | 7.2% | |
| coyoacan | 4947 | 7.0% | |
| azcapotzalco | 4216 | 5.9% | |
| alvaro obregon | 4140 | 5.8% | |
| iztacalco | 3469 | 4.9% | |
| tlalpan | 3204 | 4.5% | |
| xochimilco | 2450 | 3.4% | |
| tlahuac | 1955 | 2.7% | |
| magdalena contreras | 955 | 1.3% | |
| cuajimalpa | 892 | 1.3% | |
| milpa alta | 650 | 0.9% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 19 |
|---|---|
| Median length | 12 |
| Mean length | 12.25522489 |
| Min length | 7 |
Most occurring characters
| Value | Count | Frequency (%) | |
| a | 167946 | 19.3% | |
| o | 83837 | 9.6% | |
| c | 53771 | 6.2% | |
| t | 53563 | 6.1% | |
| l | 46520 | 5.3% | |
| e | 45808 | 5.3% | |
| u | 43869 | 5.0% | |
| 42199 | 4.8% | ||
| i | 41874 | 4.8% | |
| r | 36655 | 4.2% | |
| n | 35787 | 4.1% | |
| z | 33644 | 3.9% | |
| p | 29992 | 3.4% | |
| m | 27428 | 3.1% | |
| g | 25373 | 2.9% | |
| v | 19377 | 2.2% | |
| h | 16828 | 1.9% | |
| s | 16192 | 1.9% | |
| d | 16123 | 1.9% | |
| b | 10189 | 1.2% | |
| . | 10058 | 1.2% | |
| j | 6941 | 0.8% | |
| y | 4947 | 0.6% | |
| x | 2450 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Lowercase Letter | 819114 | 94.0% | |
| Space Separator | 42199 | 4.8% | |
| Other Punctuation | 10058 | 1.2% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| a | 167946 | 20.5% | |
| o | 83837 | 10.2% | |
| c | 53771 | 6.6% | |
| t | 53563 | 6.5% | |
| l | 46520 | 5.7% | |
| e | 45808 | 5.6% | |
| u | 43869 | 5.4% | |
| i | 41874 | 5.1% | |
| r | 36655 | 4.5% | |
| n | 35787 | 4.4% | |
| z | 33644 | 4.1% | |
| p | 29992 | 3.7% | |
| m | 27428 | 3.3% | |
| g | 25373 | 3.1% | |
| v | 19377 | 2.4% | |
| h | 16828 | 2.1% | |
| s | 16192 | 2.0% | |
| d | 16123 | 2.0% | |
| b | 10189 | 1.2% | |
| j | 6941 | 0.8% | |
| y | 4947 | 0.6% | |
| x | 2450 | 0.3% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 42199 | 100.0% |
Most frequent Other Punctuation characters
| Value | Count | Frequency (%) | |
| . | 10058 | 100.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 819114 | 94.0% | |
| Common | 52257 | 6.0% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| a | 167946 | 20.5% | |
| o | 83837 | 10.2% | |
| c | 53771 | 6.6% | |
| t | 53563 | 6.5% | |
| l | 46520 | 5.7% | |
| e | 45808 | 5.6% | |
| u | 43869 | 5.4% | |
| i | 41874 | 5.1% | |
| r | 36655 | 4.5% | |
| n | 35787 | 4.4% | |
| z | 33644 | 4.1% | |
| p | 29992 | 3.7% | |
| m | 27428 | 3.3% | |
| g | 25373 | 3.1% | |
| v | 19377 | 2.4% | |
| h | 16828 | 2.1% | |
| s | 16192 | 2.0% | |
| d | 16123 | 2.0% | |
| b | 10189 | 1.2% | |
| j | 6941 | 0.8% | |
| y | 4947 | 0.6% | |
| x | 2450 | 0.3% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 42199 | 80.8% | ||
| . | 10058 | 19.2% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 871371 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| a | 167946 | 19.3% | |
| o | 83837 | 9.6% | |
| c | 53771 | 6.2% | |
| t | 53563 | 6.1% | |
| l | 46520 | 5.3% | |
| e | 45808 | 5.3% | |
| u | 43869 | 5.0% | |
| 42199 | 4.8% | ||
| i | 41874 | 4.8% | |
| r | 36655 | 4.2% | |
| n | 35787 | 4.1% | |
| z | 33644 | 3.9% | |
| p | 29992 | 3.4% | |
| m | 27428 | 3.1% | |
| g | 25373 | 2.9% | |
| v | 19377 | 2.2% | |
| h | 16828 | 1.9% | |
| s | 16192 | 1.9% | |
| d | 16123 | 1.9% | |
| b | 10189 | 1.2% | |
| . | 10058 | 1.2% | |
| j | 6941 | 0.8% | |
| y | 4947 | 0.6% | |
| x | 2450 | 0.3% |
| Distinct | 1340 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 555.6 KiB |
| centro | 1139 |
|---|---|
| agricola oriental | 837 |
| roma norte | 602 |
| moctezuma 2a seccion | 558 |
| jardin balbuena | 498 |
| Other values (1335) |
| Value | Count | Frequency (%) | |
| centro | 1139 | 1.6% | |
| agricola oriental | 837 | 1.2% | |
| roma norte | 602 | 0.8% | |
| moctezuma 2a seccion | 558 | 0.8% | |
| jardin balbuena | 498 | 0.7% | |
| doctores | 490 | 0.7% | |
| san felipe de jesus | 419 | 0.6% | |
| obrera | 418 | 0.6% | |
| roma sur | 418 | 0.6% | |
| agricola pantitlan | 417 | 0.6% | |
| morelos | 396 | 0.6% | |
| santa maria la ribera | 367 | 0.5% | |
| leyes de reforma 3a seccion | 352 | 0.5% | |
| del carmen | 352 | 0.5% | |
| hipodromo | 348 | 0.5% | |
| narvarte poniente | 346 | 0.5% | |
| juan escutia | 337 | 0.5% | |
| cuauhtemoc | 336 | 0.5% | |
| industrial | 336 | 0.5% | |
| juarez | 332 | 0.5% | |
| guerrero | 332 | 0.5% | |
| santa maria aztahuacan | 327 | 0.5% | |
| narvarte oriente | 326 | 0.5% | |
| general ignacio zaragoza | 314 | 0.4% | |
| san pedro de los pinos | 302 | 0.4% | |
| Other values (1315) | 60203 | 84.7% |
Frequencies of value counts
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Histogram of lengths of the category
Length
| Max length | 43 |
|---|---|
| Median length | 16 |
| Mean length | 16.86555934 |
| Min length | 4 |
Most occurring characters
| Value | Count | Frequency (%) | |
| a | 165148 | 13.8% | |
| 115153 | 9.6% | ||
| e | 105626 | 8.8% | |
| o | 96794 | 8.1% | |
| n | 79163 | 6.6% | |
| l | 75632 | 6.3% | |
| r | 74184 | 6.2% | |
| i | 70109 | 5.8% | |
| s | 63800 | 5.3% | |
| c | 61399 | 5.1% | |
| t | 52523 | 4.4% | |
| u | 39028 | 3.3% | |
| d | 35090 | 2.9% | |
| p | 33770 | 2.8% | |
| m | 29396 | 2.5% | |
| b | 18703 | 1.6% | |
| g | 17917 | 1.5% | |
| v | 12376 | 1.0% | |
| z | 11378 | 0.9% | |
| h | 10973 | 0.9% | |
| j | 8944 | 0.7% | |
| f | 4675 | 0.4% | |
| x | 4094 | 0.3% | |
| y | 3344 | 0.3% | |
| 2 | 1857 | 0.2% | |
| Other values (13) | 8099 | 0.7% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Lowercase Letter | 1075502 | 89.7% | |
| Space Separator | 115153 | 9.6% | |
| Decimal Number | 5886 | 0.5% | |
| Other Punctuation | 2634 | 0.2% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 2 | 1857 | 31.5% | |
| 1 | 1575 | 26.8% | |
| 3 | 760 | 12.9% | |
| 0 | 499 | 8.5% | |
| 7 | 415 | 7.1% | |
| 5 | 261 | 4.4% | |
| 9 | 198 | 3.4% | |
| 6 | 139 | 2.4% | |
| 4 | 101 | 1.7% | |
| 8 | 81 | 1.4% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 115153 | 100.0% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| a | 165148 | 15.4% | |
| e | 105626 | 9.8% | |
| o | 96794 | 9.0% | |
| n | 79163 | 7.4% | |
| l | 75632 | 7.0% | |
| r | 74184 | 6.9% | |
| i | 70109 | 6.5% | |
| s | 63800 | 5.9% | |
| c | 61399 | 5.7% | |
| t | 52523 | 4.9% | |
| u | 39028 | 3.6% | |
| d | 35090 | 3.3% | |
| p | 33770 | 3.1% | |
| m | 29396 | 2.7% | |
| b | 18703 | 1.7% | |
| g | 17917 | 1.7% | |
| v | 12376 | 1.2% | |
| z | 11378 | 1.1% | |
| h | 10973 | 1.0% | |
| j | 8944 | 0.8% | |
| f | 4675 | 0.4% | |
| x | 4094 | 0.4% | |
| y | 3344 | 0.3% | |
| q | 1343 | 0.1% | |
| k | 93 | < 0.1% |
Most frequent Other Punctuation characters
| Value | Count | Frequency (%) | |
| . | 1838 | 69.8% | |
| & | 796 | 30.2% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 1075502 | 89.7% | |
| Common | 123673 | 10.3% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 115153 | 93.1% | ||
| 2 | 1857 | 1.5% | |
| . | 1838 | 1.5% | |
| 1 | 1575 | 1.3% | |
| & | 796 | 0.6% | |
| 3 | 760 | 0.6% | |
| 0 | 499 | 0.4% | |
| 7 | 415 | 0.3% | |
| 5 | 261 | 0.2% | |
| 9 | 198 | 0.2% | |
| 6 | 139 | 0.1% | |
| 4 | 101 | 0.1% | |
| 8 | 81 | 0.1% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| a | 165148 | 15.4% | |
| e | 105626 | 9.8% | |
| o | 96794 | 9.0% | |
| n | 79163 | 7.4% | |
| l | 75632 | 7.0% | |
| r | 74184 | 6.9% | |
| i | 70109 | 6.5% | |
| s | 63800 | 5.9% | |
| c | 61399 | 5.7% | |
| t | 52523 | 4.9% | |
| u | 39028 | 3.6% | |
| d | 35090 | 3.3% | |
| p | 33770 | 3.1% | |
| m | 29396 | 2.7% | |
| b | 18703 | 1.7% | |
| g | 17917 | 1.7% | |
| v | 12376 | 1.2% | |
| z | 11378 | 1.1% | |
| h | 10973 | 1.0% | |
| j | 8944 | 0.8% | |
| f | 4675 | 0.4% | |
| x | 4094 | 0.4% | |
| y | 3344 | 0.3% | |
| q | 1343 | 0.1% | |
| k | 93 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 1199175 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| a | 165148 | 13.8% | |
| 115153 | 9.6% | ||
| e | 105626 | 8.8% | |
| o | 96794 | 8.1% | |
| n | 79163 | 6.6% | |
| l | 75632 | 6.3% | |
| r | 74184 | 6.2% | |
| i | 70109 | 5.8% | |
| s | 63800 | 5.3% | |
| c | 61399 | 5.1% | |
| t | 52523 | 4.4% | |
| u | 39028 | 3.3% | |
| d | 35090 | 2.9% | |
| p | 33770 | 2.8% | |
| m | 29396 | 2.5% | |
| b | 18703 | 1.6% | |
| g | 17917 | 1.5% | |
| v | 12376 | 1.0% | |
| z | 11378 | 0.9% | |
| h | 10973 | 0.9% | |
| j | 8944 | 0.7% | |
| f | 4675 | 0.4% | |
| x | 4094 | 0.3% | |
| y | 3344 | 0.3% | |
| 2 | 1857 | 0.2% | |
| Other values (13) | 8099 | 0.7% |
| Distinct | 31911 |
|---|---|
| Distinct (%) | 50.8% |
| Missing | 8327 |
| Missing (%) | 11.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 50.63623377 |
|---|---|
| Minimum | 0 |
| Maximum | 11702.22 |
| Zeros | 17715 |
| Zeros (%) | 24.9% |
| Memory size | 555.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 33.45166667 |
| Q3 | 61.21654793 |
| 95-th percentile | 162.2529989 |
| Maximum | 11702.22 |
| Range | 11702.22 |
| Interquartile range (IQR) | 61.21654793 |
Descriptive statistics
| Standard deviation | 130.4086734 |
|---|---|
| Coefficient of variation (CV) | 2.575402309 |
| Kurtosis | 3263.991441 |
| Mean | 50.63623377 |
| Median Absolute Deviation (MAD) | 33.33333333 |
| Skewness | 43.60044406 |
| Sum | 3178689.575 |
| Variance | 17006.42209 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 17715 | 24.9% | |
| 36 | 58 | 0.1% | |
| 29.28 | 57 | 0.1% | |
| 36.6 | 53 | 0.1% | |
| 23.8 | 49 | 0.1% | |
| 25.62 | 48 | 0.1% | |
| 26.84 | 47 | 0.1% | |
| 18.92 | 45 | 0.1% | |
| 11.6 | 45 | 0.1% | |
| 1.84 | 45 | 0.1% | |
| 17.7 | 44 | 0.1% | |
| 16.48 | 43 | 0.1% | |
| 61 | 42 | 0.1% | |
| 3.06 | 40 | 0.1% | |
| 33.56 | 39 | 0.1% | |
| 14.04 | 39 | 0.1% | |
| 43.32 | 39 | 0.1% | |
| 18.3 | 39 | 0.1% | |
| 19.52 | 38 | 0.1% | |
| 4.88 | 38 | 0.1% | |
| 10.98 | 38 | 0.1% | |
| 26.24 | 38 | 0.1% | |
| 46.98 | 38 | 0.1% | |
| 28.68 | 36 | 0.1% | |
| 57.96 | 35 | < 0.1% | |
| Other values (31886) | 44027 | 61.9% | |
| (Missing) | 8327 | 11.7% |
| Value | Count | Frequency (%) | |
| 0 | 17715 | 24.9% | |
| 0.1199999973 | 2 | < 0.1% | |
| 0.1899999976 | 1 | < 0.1% | |
| 0.19 | 2 | < 0.1% | |
| 0.2399999946 | 1 | < 0.1% | |
| 0.24 | 2 | < 0.1% | |
| 0.27 | 2 | < 0.1% | |
| 0.2700000107 | 1 | < 0.1% | |
| 0.349999994 | 2 | < 0.1% | |
| 0.35 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 11702.22 | 1 | < 0.1% | |
| 11529.44971 | 1 | < 0.1% | |
| 11515.53 | 1 | < 0.1% | |
| 5808 | 3 | < 0.1% | |
| 4919.04 | 1 | < 0.1% | |
| 4331.01 | 2 | < 0.1% | |
| 4183.38 | 1 | < 0.1% | |
| 3916.199951 | 1 | < 0.1% | |
| 3649.75 | 1 | < 0.1% | |
| 3647.15 | 1 | < 0.1% |
| Distinct | 56015 |
|---|---|
| Distinct (%) | 78.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1695.847222 |
|---|---|
| Minimum | 0 |
| Maximum | 119726.94 |
| Zeros | 2451 |
| Zeros (%) | 3.4% |
| Memory size | 555.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 6.49 |
| Q1 | 340.9525 |
| median | 896.175 |
| Q3 | 1808.9025 |
| 95-th percentile | 5564.1965 |
| Maximum | 119726.94 |
| Range | 119726.94 |
| Interquartile range (IQR) | 1467.95 |
Descriptive statistics
| Standard deviation | 3555.697457 |
|---|---|
| Coefficient of variation (CV) | 2.096708601 |
| Kurtosis | 195.8775277 |
| Mean | 1695.847222 |
| Median Absolute Deviation (MAD) | 664.505 |
| Skewness | 10.99825971 |
| Sum | 120578129.2 |
| Variance | 12642984.41 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 2451 | 3.4% | |
| 3.05 | 70 | 0.1% | |
| 1.22 | 68 | 0.1% | |
| 3.66 | 42 | 0.1% | |
| 6.71 | 41 | 0.1% | |
| 1.83 | 40 | 0.1% | |
| 7.93 | 39 | 0.1% | |
| 4.88 | 36 | 0.1% | |
| 6.1 | 36 | 0.1% | |
| 9.76 | 36 | 0.1% | |
| 12.81 | 35 | < 0.1% | |
| 1.18 | 34 | < 0.1% | |
| 4.27 | 34 | < 0.1% | |
| 8.54 | 34 | < 0.1% | |
| 11.59 | 33 | < 0.1% | |
| 4.13 | 32 | < 0.1% | |
| 18.3 | 32 | < 0.1% | |
| 17.69 | 30 | < 0.1% | |
| 19.52 | 29 | < 0.1% | |
| 1.77 | 27 | < 0.1% | |
| 10.37 | 27 | < 0.1% | |
| 7.32 | 26 | < 0.1% | |
| 14.64 | 26 | < 0.1% | |
| 35.99 | 25 | < 0.1% | |
| 8.26 | 25 | < 0.1% | |
| Other values (55990) | 67794 | 95.3% |
| Value | Count | Frequency (%) | |
| 0 | 2451 | 3.4% | |
| 0.01 | 3 | < 0.1% | |
| 0.05 | 3 | < 0.1% | |
| 0.12 | 5 | < 0.1% | |
| 0.24 | 18 | < 0.1% | |
| 0.25 | 3 | < 0.1% | |
| 0.35 | 3 | < 0.1% | |
| 0.37 | 3 | < 0.1% | |
| 0.48 | 4 | < 0.1% | |
| 0.49 | 8 | < 0.1% |
| Value | Count | Frequency (%) | |
| 119726.94 | 1 | < 0.1% | |
| 117150.91 | 1 | < 0.1% | |
| 101035 | 1 | < 0.1% | |
| 95117.77 | 1 | < 0.1% | |
| 94078.2 | 1 | < 0.1% | |
| 90132.54 | 1 | < 0.1% | |
| 89691.8 | 1 | < 0.1% | |
| 88204.37 | 1 | < 0.1% | |
| 87179.61 | 1 | < 0.1% | |
| 86659.24 | 1 | < 0.1% |
| Distinct | 62214 |
|---|---|
| Distinct (%) | 87.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 111.2173991 |
|---|---|
| Minimum | 0 |
| Maximum | 89691.77344 |
| Zeros | 2451 |
| Zeros (%) | 3.4% |
| Memory size | 555.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3.867208333 |
| Q1 | 23.01013907 |
| median | 31.69381809 |
| Q3 | 45.48491686 |
| 95-th percentile | 188.219501 |
| Maximum | 89691.77344 |
| Range | 89691.77344 |
| Interquartile range (IQR) | 22.47477779 |
Descriptive statistics
| Standard deviation | 1069.949262 |
|---|---|
| Coefficient of variation (CV) | 9.620340614 |
| Kurtosis | 2599.541185 |
| Mean | 111.2173991 |
| Median Absolute Deviation (MAD) | 10.31349875 |
| Skewness | 43.38268186 |
| Sum | 7907779.51 |
| Variance | 1144791.422 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 2451 | 3.4% | |
| 1.22 | 62 | 0.1% | |
| 3.05 | 55 | 0.1% | |
| 4.27 | 43 | 0.1% | |
| 6.71 | 39 | 0.1% | |
| 1.83 | 38 | 0.1% | |
| 4.88 | 38 | 0.1% | |
| 3.66 | 38 | 0.1% | |
| 9.76 | 37 | 0.1% | |
| 7.93 | 36 | 0.1% | |
| 6.1 | 36 | 0.1% | |
| 12.81 | 34 | < 0.1% | |
| 4.130000114 | 33 | < 0.1% | |
| 1.179999948 | 29 | < 0.1% | |
| 11.59 | 29 | < 0.1% | |
| 7.32 | 29 | < 0.1% | |
| 0.61 | 28 | < 0.1% | |
| 14.03 | 27 | < 0.1% | |
| 8.54 | 26 | < 0.1% | |
| 1.769999981 | 26 | < 0.1% | |
| 9.15 | 25 | < 0.1% | |
| 18.3 | 25 | < 0.1% | |
| 19.52 | 24 | < 0.1% | |
| 23.18 | 24 | < 0.1% | |
| 2.950000048 | 22 | < 0.1% | |
| Other values (62189) | 67848 | 95.4% |
| Value | Count | Frequency (%) | |
| 0 | 2451 | 3.4% | |
| 0.009999999776 | 1 | < 0.1% | |
| 0.01 | 2 | < 0.1% | |
| 0.05 | 2 | < 0.1% | |
| 0.05000000075 | 1 | < 0.1% | |
| 0.06 | 1 | < 0.1% | |
| 0.1199999973 | 3 | < 0.1% | |
| 0.12 | 5 | < 0.1% | |
| 0.1633333333 | 2 | < 0.1% | |
| 0.2066666667 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 89691.77344 | 1 | < 0.1% | |
| 87179.61 | 1 | < 0.1% | |
| 80555.01 | 1 | < 0.1% | |
| 56873.96 | 1 | < 0.1% | |
| 54935.99 | 1 | < 0.1% | |
| 52980.94 | 1 | < 0.1% | |
| 51507 | 1 | < 0.1% | |
| 50485.43 | 1 | < 0.1% | |
| 48840.78906 | 1 | < 0.1% | |
| 44102.185 | 1 | < 0.1% |
| Distinct | 37440 |
|---|---|
| Distinct (%) | 52.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 126.7601718 |
|---|---|
| Minimum | 0 |
| Maximum | 89691.77344 |
| Zeros | 8109 |
| Zeros (%) | 11.4% |
| Memory size | 555.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 6.2754167 |
| median | 19.28000034 |
| Q3 | 54.186875 |
| 95-th percentile | 333.6616663 |
| Maximum | 89691.77344 |
| Range | 89691.77344 |
| Interquartile range (IQR) | 47.9114583 |
Descriptive statistics
| Standard deviation | 1095.817805 |
|---|---|
| Coefficient of variation (CV) | 8.64481161 |
| Kurtosis | 2364.161672 |
| Mean | 126.7601718 |
| Median Absolute Deviation (MAD) | 16.85000034 |
| Skewness | 40.71654298 |
| Sum | 9012901.734 |
| Variance | 1200816.661 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 8109 | 11.4% | |
| 1.22 | 330 | 0.5% | |
| 1.83 | 290 | 0.4% | |
| 3.05 | 260 | 0.4% | |
| 4.27 | 216 | 0.3% | |
| 7.93 | 203 | 0.3% | |
| 3.66 | 202 | 0.3% | |
| 4.88 | 201 | 0.3% | |
| 6.1 | 193 | 0.3% | |
| 6.71 | 190 | 0.3% | |
| 1.179999948 | 174 | 0.2% | |
| 9.76 | 173 | 0.2% | |
| 9.15 | 168 | 0.2% | |
| 8.54 | 167 | 0.2% | |
| 11.59 | 158 | 0.2% | |
| 10.98 | 155 | 0.2% | |
| 0.61 | 153 | 0.2% | |
| 2.950000048 | 146 | 0.2% | |
| 7.32 | 140 | 0.2% | |
| 1.769999981 | 137 | 0.2% | |
| 12.81 | 135 | 0.2% | |
| 12.2 | 128 | 0.2% | |
| 5.49 | 126 | 0.2% | |
| 2.44 | 122 | 0.2% | |
| 4.130000114 | 118 | 0.2% | |
| Other values (37415) | 58708 | 82.6% |
| Value | Count | Frequency (%) | |
| 0 | 8109 | 11.4% | |
| 0.009999999776 | 1 | < 0.1% | |
| 0.01 | 2 | < 0.1% | |
| 0.012 | 1 | < 0.1% | |
| 0.01499999966 | 1 | < 0.1% | |
| 0.015 | 2 | < 0.1% | |
| 0.02 | 1 | < 0.1% | |
| 0.03 | 1 | < 0.1% | |
| 0.03428571352 | 1 | < 0.1% | |
| 0.036 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 89691.77344 | 1 | < 0.1% | |
| 87179.61 | 1 | < 0.1% | |
| 80555.01 | 1 | < 0.1% | |
| 56873.96 | 1 | < 0.1% | |
| 54935.99 | 1 | < 0.1% | |
| 52980.94 | 1 | < 0.1% | |
| 51507 | 1 | < 0.1% | |
| 50485.43 | 1 | < 0.1% | |
| 48840.78906 | 1 | < 0.1% | |
| 44102.185 | 1 | < 0.1% |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 555.6 KiB |
| 2 | |
|---|---|
| 3 | |
| 1 |
| Value | Count | Frequency (%) | |
| 2 | 23942 | 33.7% | |
| 3 | 23822 | 33.5% | |
| 1 | 23338 | 32.8% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Most occurring characters
| Value | Count | Frequency (%) | |
| 2 | 23942 | 33.7% | |
| 3 | 23822 | 33.5% | |
| 1 | 23338 | 32.8% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Decimal Number | 71102 | 100.0% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 2 | 23942 | 33.7% | |
| 3 | 23822 | 33.5% | |
| 1 | 23338 | 32.8% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Common | 71102 | 100.0% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 2 | 23942 | 33.7% | |
| 3 | 23822 | 33.5% | |
| 1 | 23338 | 32.8% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 71102 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| 2 | 23942 | 33.7% | |
| 3 | 23822 | 33.5% | |
| 1 | 23338 | 32.8% |
| Distinct | 27336 |
|---|---|
| Distinct (%) | 38.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 436.0603092 |
|---|---|
| Minimum | 0 |
| Maximum | 119726.94 |
| Zeros | 8109 |
| Zeros (%) | 11.4% |
| Memory size | 555.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 10.98 |
| median | 54.055 |
| Q3 | 230.43 |
| 95-th percentile | 1695.6175 |
| Maximum | 119726.94 |
| Range | 119726.94 |
| Interquartile range (IQR) | 219.45 |
Descriptive statistics
| Standard deviation | 2126.152162 |
|---|---|
| Coefficient of variation (CV) | 4.875821343 |
| Kurtosis | 798.0749258 |
| Mean | 436.0603092 |
| Median Absolute Deviation (MAD) | 52.875 |
| Skewness | 22.5073679 |
| Sum | 31004760.1 |
| Variance | 4520523.018 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 8109 | 11.4% | |
| 1.22 | 402 | 0.6% | |
| 1.83 | 316 | 0.4% | |
| 3.05 | 302 | 0.4% | |
| 7.93 | 219 | 0.3% | |
| 1.18 | 217 | 0.3% | |
| 4.88 | 212 | 0.3% | |
| 4.27 | 212 | 0.3% | |
| 3.66 | 211 | 0.3% | |
| 6.1 | 195 | 0.3% | |
| 6.71 | 190 | 0.3% | |
| 11.59 | 187 | 0.3% | |
| 8.54 | 182 | 0.3% | |
| 9.15 | 181 | 0.3% | |
| 9.76 | 178 | 0.3% | |
| 2.95 | 177 | 0.2% | |
| 10.98 | 163 | 0.2% | |
| 12.81 | 161 | 0.2% | |
| 1.77 | 151 | 0.2% | |
| 7.32 | 149 | 0.2% | |
| 13.42 | 141 | 0.2% | |
| 14.03 | 138 | 0.2% | |
| 18.3 | 133 | 0.2% | |
| 4.13 | 129 | 0.2% | |
| 12.2 | 128 | 0.2% | |
| Other values (27311) | 58319 | 82.0% |
| Value | Count | Frequency (%) | |
| 0 | 8109 | 11.4% | |
| 0.01 | 3 | < 0.1% | |
| 0.03 | 1 | < 0.1% | |
| 0.05 | 3 | < 0.1% | |
| 0.08 | 1 | < 0.1% | |
| 0.12 | 23 | < 0.1% | |
| 0.14 | 1 | < 0.1% | |
| 0.18 | 1 | < 0.1% | |
| 0.24 | 57 | 0.1% | |
| 0.25 | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 119726.94 | 1 | < 0.1% | |
| 117150.91 | 1 | < 0.1% | |
| 101035 | 1 | < 0.1% | |
| 89691.8 | 1 | < 0.1% | |
| 88204.37 | 1 | < 0.1% | |
| 87179.61 | 1 | < 0.1% | |
| 86659.24 | 1 | < 0.1% | |
| 84241.4 | 1 | < 0.1% | |
| 80856.11 | 1 | < 0.1% | |
| 80555.01 | 1 | < 0.1% |
| Distinct | 71102 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35551.5 |
|---|---|
| Minimum | 1 |
| Maximum | 71102 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 555.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3556.05 |
| Q1 | 17776.25 |
| median | 35551.5 |
| Q3 | 53326.75 |
| 95-th percentile | 67546.95 |
| Maximum | 71102 |
| Range | 71101 |
| Interquartile range (IQR) | 35550.5 |
Descriptive statistics
| Standard deviation | 20525.52376 |
|---|---|
| Coefficient of variation (CV) | 0.5773462092 |
| Kurtosis | -1.2 |
| Mean | 35551.5 |
| Median Absolute Deviation (MAD) | 17775.5 |
| Skewness | -2.602398177e-17 |
| Sum | 2527782753 |
| Variance | 421297125.5 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 6806 | 1 | < 0.1% | |
| 10896 | 1 | < 0.1% | |
| 8849 | 1 | < 0.1% | |
| 14994 | 1 | < 0.1% | |
| 12947 | 1 | < 0.1% | |
| 2708 | 1 | < 0.1% | |
| 661 | 1 | < 0.1% | |
| 4759 | 1 | < 0.1% | |
| 21151 | 1 | < 0.1% | |
| 27288 | 1 | < 0.1% | |
| 25241 | 1 | < 0.1% | |
| 31386 | 1 | < 0.1% | |
| 29339 | 1 | < 0.1% | |
| 19100 | 1 | < 0.1% | |
| 17053 | 1 | < 0.1% | |
| 53903 | 1 | < 0.1% | |
| 55950 | 1 | < 0.1% | |
| 49805 | 1 | < 0.1% | |
| 51852 | 1 | < 0.1% | |
| 62091 | 1 | < 0.1% | |
| 64138 | 1 | < 0.1% | |
| 57993 | 1 | < 0.1% | |
| 60040 | 1 | < 0.1% | |
| 37511 | 1 | < 0.1% | |
| Other values (71077) | 71077 | > 99.9% |
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 71102 | 1 | < 0.1% | |
| 71101 | 1 | < 0.1% | |
| 71100 | 1 | < 0.1% | |
| 71099 | 1 | < 0.1% | |
| 71098 | 1 | < 0.1% | |
| 71097 | 1 | < 0.1% | |
| 71096 | 1 | < 0.1% | |
| 71095 | 1 | < 0.1% | |
| 71094 | 1 | < 0.1% | |
| 71093 | 1 | < 0.1% |
indice_des
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 555.6 KiB |
| bajo | |
|---|---|
| popular | |
| alto | |
| medio |
| Value | Count | Frequency (%) | |
| bajo | 29248 | 41.1% | |
| popular | 16539 | 23.3% | |
| alto | 15516 | 21.8% | |
| medio | 9799 | 13.8% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 7 |
|---|---|
| Median length | 4 |
| Mean length | 4.835644567 |
| Min length | 4 |
Most occurring characters
| Value | Count | Frequency (%) | |
| o | 71102 | 20.7% | |
| a | 61303 | 17.8% | |
| p | 33078 | 9.6% | |
| l | 32055 | 9.3% | |
| b | 29248 | 8.5% | |
| j | 29248 | 8.5% | |
| u | 16539 | 4.8% | |
| r | 16539 | 4.8% | |
| t | 15516 | 4.5% | |
| m | 9799 | 2.9% | |
| e | 9799 | 2.9% | |
| d | 9799 | 2.9% | |
| i | 9799 | 2.9% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Lowercase Letter | 343824 | 100.0% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| o | 71102 | 20.7% | |
| a | 61303 | 17.8% | |
| p | 33078 | 9.6% | |
| l | 32055 | 9.3% | |
| b | 29248 | 8.5% | |
| j | 29248 | 8.5% | |
| u | 16539 | 4.8% | |
| r | 16539 | 4.8% | |
| t | 15516 | 4.5% | |
| m | 9799 | 2.9% | |
| e | 9799 | 2.9% | |
| d | 9799 | 2.9% | |
| i | 9799 | 2.9% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 343824 | 100.0% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| o | 71102 | 20.7% | |
| a | 61303 | 17.8% | |
| p | 33078 | 9.6% | |
| l | 32055 | 9.3% | |
| b | 29248 | 8.5% | |
| j | 29248 | 8.5% | |
| u | 16539 | 4.8% | |
| r | 16539 | 4.8% | |
| t | 15516 | 4.5% | |
| m | 9799 | 2.9% | |
| e | 9799 | 2.9% | |
| d | 9799 | 2.9% | |
| i | 9799 | 2.9% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 343824 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| o | 71102 | 20.7% | |
| a | 61303 | 17.8% | |
| p | 33078 | 9.6% | |
| l | 32055 | 9.3% | |
| b | 29248 | 8.5% | |
| j | 29248 | 8.5% | |
| u | 16539 | 4.8% | |
| r | 16539 | 4.8% | |
| t | 15516 | 4.5% | |
| m | 9799 | 2.9% | |
| e | 9799 | 2.9% | |
| d | 9799 | 2.9% | |
| i | 9799 | 2.9% |
latitud
Real number (ℝ≥0)
| Distinct | 22930 |
|---|---|
| Distinct (%) | 32.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.39227276 |
|---|---|
| Minimum | 19.13586653 |
| Maximum | 19.57910261 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 555.6 KiB |
Quantile statistics
| Minimum | 19.13586653 |
|---|---|
| 5-th percentile | 19.27217463 |
| Q1 | 19.34407317 |
| median | 19.39291026 |
| Q3 | 19.44681849 |
| 95-th percentile | 19.49744601 |
| Maximum | 19.57910261 |
| Range | 0.4432360842 |
| Interquartile range (IQR) | 0.1027453211 |
Descriptive statistics
| Standard deviation | 0.07054946408 |
|---|---|
| Coefficient of variation (CV) | 0.003638019377 |
| Kurtosis | -0.3299967947 |
| Mean | 19.39227276 |
| Median Absolute Deviation (MAD) | 0.05121505235 |
| Skewness | -0.2209675789 |
| Sum | 1378829.378 |
| Variance | 0.004977226881 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 19.30094699 | 21 | < 0.1% | |
| 19.49545978 | 21 | < 0.1% | |
| 19.51126852 | 21 | < 0.1% | |
| 19.44888183 | 21 | < 0.1% | |
| 19.50314865 | 21 | < 0.1% | |
| 19.51433121 | 21 | < 0.1% | |
| 19.51081678 | 21 | < 0.1% | |
| 19.49661646 | 13 | < 0.1% | |
| 19.41716896 | 13 | < 0.1% | |
| 19.51160136 | 12 | < 0.1% | |
| 19.49726649 | 10 | < 0.1% | |
| 19.5206852 | 10 | < 0.1% | |
| 19.47038443 | 10 | < 0.1% | |
| 19.47224001 | 10 | < 0.1% | |
| 19.45796266 | 10 | < 0.1% | |
| 19.4856474 | 10 | < 0.1% | |
| 19.37734143 | 10 | < 0.1% | |
| 19.45252973 | 10 | < 0.1% | |
| 19.39466574 | 10 | < 0.1% | |
| 19.29887148 | 10 | < 0.1% | |
| 19.26582671 | 10 | < 0.1% | |
| 19.45526019 | 10 | < 0.1% | |
| 19.29670397 | 10 | < 0.1% | |
| 19.444672 | 10 | < 0.1% | |
| 19.39856363 | 10 | < 0.1% | |
| Other values (22905) | 70767 | 99.5% |
| Value | Count | Frequency (%) | |
| 19.13586653 | 3 | < 0.1% | |
| 19.13628997 | 3 | < 0.1% | |
| 19.16951445 | 2 | < 0.1% | |
| 19.1728973 | 3 | < 0.1% | |
| 19.173993 | 3 | < 0.1% | |
| 19.17467693 | 3 | < 0.1% | |
| 19.17493291 | 3 | < 0.1% | |
| 19.17544228 | 3 | < 0.1% | |
| 19.1755079 | 3 | < 0.1% | |
| 19.17571262 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 19.57910261 | 3 | < 0.1% | |
| 19.57503233 | 3 | < 0.1% | |
| 19.57456726 | 3 | < 0.1% | |
| 19.5718567 | 3 | < 0.1% | |
| 19.57141877 | 3 | < 0.1% | |
| 19.57031035 | 3 | < 0.1% | |
| 19.56938495 | 3 | < 0.1% | |
| 19.56920145 | 3 | < 0.1% | |
| 19.56850437 | 3 | < 0.1% | |
| 19.5682942 | 3 | < 0.1% |
longitud
Real number (ℝ)
| Distinct | 22930 |
|---|---|
| Distinct (%) | 32.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -99.13289588 |
|---|---|
| Minimum | -99.33770342 |
| Maximum | -98.95046917 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 555.6 KiB |
Quantile statistics
| Minimum | -99.33770342 |
|---|---|
| 5-th percentile | -99.2236241 |
| Q1 | -99.17248433 |
| median | -99.13519579 |
| Q3 | -99.09663337 |
| 95-th percentile | -99.02915715 |
| Maximum | -98.95046917 |
| Range | 0.3872342535 |
| Interquartile range (IQR) | 0.07585096428 |
Descriptive statistics
| Standard deviation | 0.05789023819 |
|---|---|
| Coefficient of variation (CV) | -0.0005839659749 |
| Kurtosis | 0.03317853179 |
| Mean | -99.13289588 |
| Median Absolute Deviation (MAD) | 0.0378663909 |
| Skewness | 0.1247230301 |
| Sum | -7048547.163 |
| Variance | 0.003351279677 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| -99.08903493 | 21 | < 0.1% | |
| -99.20751574 | 21 | < 0.1% | |
| -99.14369261 | 21 | < 0.1% | |
| -99.13756286 | 21 | < 0.1% | |
| -99.20421465 | 21 | < 0.1% | |
| -99.18589472 | 21 | < 0.1% | |
| -99.15821728 | 21 | < 0.1% | |
| -99.19306813 | 13 | < 0.1% | |
| -99.17071426 | 13 | < 0.1% | |
| -99.14127961 | 12 | < 0.1% | |
| -99.16004436 | 10 | < 0.1% | |
| -99.19422534 | 10 | < 0.1% | |
| -99.1837565 | 10 | < 0.1% | |
| -99.2033357 | 10 | < 0.1% | |
| -99.15176779 | 10 | < 0.1% | |
| -99.11289989 | 10 | < 0.1% | |
| -99.15468291 | 10 | < 0.1% | |
| -99.136565 | 10 | < 0.1% | |
| -99.13909924 | 10 | < 0.1% | |
| -99.18986966 | 10 | < 0.1% | |
| -99.13825639 | 10 | < 0.1% | |
| -99.13799567 | 10 | < 0.1% | |
| -99.1239696 | 10 | < 0.1% | |
| -99.12357268 | 10 | < 0.1% | |
| -99.13236902 | 10 | < 0.1% | |
| Other values (22905) | 70767 | 99.5% |
| Value | Count | Frequency (%) | |
| -99.33770342 | 3 | < 0.1% | |
| -99.32799413 | 3 | < 0.1% | |
| -99.32592098 | 3 | < 0.1% | |
| -99.32544326 | 3 | < 0.1% | |
| -99.32502513 | 3 | < 0.1% | |
| -99.32392647 | 3 | < 0.1% | |
| -99.32319321 | 3 | < 0.1% | |
| -99.31905135 | 3 | < 0.1% | |
| -99.31876126 | 3 | < 0.1% | |
| -99.31856265 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| -98.95046917 | 3 | < 0.1% | |
| -98.95128667 | 3 | < 0.1% | |
| -98.95334634 | 3 | < 0.1% | |
| -98.95408029 | 3 | < 0.1% | |
| -98.95769198 | 3 | < 0.1% | |
| -98.9596481 | 3 | < 0.1% | |
| -98.96048267 | 3 | < 0.1% | |
| -98.96149327 | 3 | < 0.1% | |
| -98.96170729 | 3 | < 0.1% | |
| -98.96257644 | 3 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| consumo_total_mixto | anio | nomgeo | consumo_prom_dom | consumo_total_dom | alcaldia | colonia | consumo_prom_mixto | consumo_total | consumo_prom | consumo_prom_no_dom | bimestre | consumo_total_no_dom | gid | indice_des | latitud | longitud | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 159.72 | 2019 | gustavo a. madero | 42.566364 | 468.23 | gustavo a. madero | 7 de noviembre | 53.24000 | 631.00 | 42.066667 | 3.050000 | 3 | 3.05 | 57250 | alto | 19.455260 | -99.112662 |
| 1 | 0.00 | 2019 | gustavo a. madero | 35.936667 | 107.81 | gustavo a. madero | 7 de noviembre | 0.00000 | 115.13 | 28.782500 | 7.320000 | 3 | 7.32 | 57253 | medio | 19.455260 | -99.112662 |
| 2 | 0.00 | 2019 | gustavo a. madero | 24.586000 | 122.93 | gustavo a. madero | 7 de noviembre | 0.00000 | 197.96 | 32.993333 | 75.030000 | 3 | 75.03 | 57255 | popular | 19.455720 | -99.113582 |
| 3 | 0.00 | 2019 | gustavo a. madero | 0.000000 | 0.00 | gustavo a. madero | nueva tenochtitlan | 0.00000 | 253.53 | 84.510000 | 84.510000 | 3 | 253.53 | 57267 | bajo | 19.459647 | -99.104469 |
| 4 | 56.72 | 2019 | azcapotzalco | 67.436250 | 539.49 | azcapotzalco | prohogar | 56.72000 | 839.35 | 76.304545 | 121.570000 | 3 | 243.14 | 57330 | bajo | 19.474161 | -99.146750 |
| 5 | 439.77 | 2019 | azcapotzalco | 35.675769 | 927.57 | azcapotzalco | trabajadores del hierro | 54.97125 | 1399.67 | 37.828919 | 10.776667 | 3 | 32.33 | 57273 | bajo | 19.478613 | -99.150571 |
| 6 | 991.80 | 2019 | azcapotzalco | 22.381884 | 4633.05 | azcapotzalco | barrio coltongo | 123.97500 | 7693.64 | 33.305801 | 129.299375 | 3 | 2068.79 | 57275 | bajo | 19.480211 | -99.152316 |
| 7 | 0.00 | 2019 | azcapotzalco | 0.000000 | 0.00 | azcapotzalco | barrio coltongo | 0.00000 | 305.00 | 152.500000 | 152.500000 | 3 | 305.00 | 57276 | popular | 19.479096 | -99.148920 |
| 8 | 184.86 | 2019 | azcapotzalco | 33.661176 | 1716.72 | azcapotzalco | trabajadores del hierro | 46.21500 | 1903.66 | 33.993929 | 2.080000 | 3 | 2.08 | 57277 | bajo | 19.478585 | -99.148847 |
| 9 | 10.98 | 2019 | azcapotzalco | 51.912500 | 207.65 | azcapotzalco | trabajadores del hierro | 10.98000 | 237.54 | 29.692500 | 6.303333 | 3 | 18.91 | 57281 | bajo | 19.477273 | -99.147921 |
Last rows
| consumo_total_mixto | anio | nomgeo | consumo_prom_dom | consumo_total_dom | alcaldia | colonia | consumo_prom_mixto | consumo_total | consumo_prom | consumo_prom_no_dom | bimestre | consumo_total_no_dom | gid | indice_des | latitud | longitud | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 71092 | 148.44 | 2019 | cuauhtémoc | 22.144688 | 708.63 | cuauhtemoc | guerrero | 37.110000 | 867.10 | 23.435135 | 10.030000 | 1 | 10.03 | 226 | bajo | 19.451196 | -99.144366 |
| 71093 | 105.78 | 2019 | cuauhtémoc | 23.407368 | 889.48 | cuauhtemoc | guerrero | 26.445001 | 1006.37 | 23.403954 | 11.110000 | 1 | 11.11 | 227 | bajo | 19.451146 | -99.144016 |
| 71094 | 336.23 | 2019 | cuauhtémoc | 24.441459 | 11560.80 | cuauhtemoc | guerrero | 56.038333 | 13188.20 | 25.910059 | 43.039333 | 1 | 1291.18 | 228 | bajo | 19.450613 | -99.142731 |
| 71095 | NaN | 2019 | cuauhtémoc | 42.221111 | 379.99 | cuauhtemoc | guerrero | NaN | 379.99 | 37.999000 | 0.000000 | 1 | 0.00 | 229 | bajo | 19.449764 | -99.142259 |
| 71096 | 794.27 | 2019 | cuauhtémoc | 16.367010 | 1751.27 | cuauhtemoc | guerrero | 397.134987 | 2563.63 | 23.095766 | 9.045000 | 1 | 18.09 | 232 | bajo | 19.448385 | -99.139017 |
| 71097 | NaN | 2019 | cuauhtémoc | 20.053112 | 3930.41 | cuauhtemoc | guerrero | NaN | 4286.28 | 19.307568 | 13.687308 | 1 | 355.87 | 233 | bajo | 19.448564 | -99.139940 |
| 71098 | 71.30 | 2019 | cuauhtémoc | 21.126615 | 9549.24 | cuauhtemoc | guerrero | 35.650001 | 9796.12 | 20.976702 | 13.506923 | 1 | 175.59 | 238 | popular | 19.449339 | -99.145719 |
| 71099 | 759.16 | 2019 | cuauhtémoc | 27.527778 | 4707.25 | cuauhtemoc | guerrero | 94.894999 | 5692.81 | 29.344381 | 15.093334 | 1 | 226.40 | 239 | bajo | 19.448392 | -99.145930 |
| 71100 | 402.65 | 2019 | cuauhtémoc | 30.605000 | 550.89 | cuauhtemoc | guerrero | 100.662498 | 963.15 | 41.876087 | 9.610000 | 1 | 9.61 | 244 | bajo | 19.447587 | -99.142509 |
| 71101 | 41.20 | 2019 | cuauhtémoc | 22.507710 | 8552.94 | cuauhtemoc | guerrero | 13.733333 | 9000.07 | 21.951366 | 15.034444 | 1 | 405.93 | 247 | bajo | 19.447402 | -99.139725 |